revDatabaseTableNames

Type

function

Summary

Returns a list of the table names in the current database.

Syntax

revDatabaseTableNames(<databaseID>)

Description

You can use the revDatabaseTableNames function to verify that a user-specified table name is correct or to display a list of tables for the user to choose between.

Important

The revDatabaseTableNames function is part of the Database library. To ensure that the function works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions section of the General screen of the Standalone Application Settings window, make sure the "Database Support" checkbox is checked and the database drivers you are using are selected in the list of database drivers.

Parameters

Name	Type	Description
databaseID		The number returned by the revOpenDatabase function when the database was opened.

Examples

if tTableName is among the lines \
      of revDatabaseTableNames(sgDatabaseId) then
  insertData tTableName, tData
end if

Related

command: revExecuteSQL

function: revOpenDatabase

Compatibility and Support

Introduced

LiveCode 1.1.1

OS

mac

windows

linux

ios

android

Platforms

desktop

server

mobile